About Course

  • This course is a type of financial modeling course that teaches how to build a pro forma model for a merger or acquisition transaction. A pro forma model is a projection of the combined financial statements of the acquirer and the target after the deal is completed.
  • It shows the impact of the transaction on key metrics such as revenue, earnings, cash flow, and valuation. A Mergers & Acquisition Modelling course typically covers topics such as:
    • How to structure an M&A model in Excel.
    • How to set up the sources and uses of cash for the deal.
    • How to adjust the balance sheet for the purchase price allocation and goodwill.
    • How to forecast the income statement and cash flow statement of the combined entity.
    • How to calculate the accretion or dilution of earnings per share and other ratios.
    • How to perform sensitivity analysis on various assumptions and scenarios.
    • How to evaluate the strategic rationale and synergies of the deal.



Eligibilities

--- Finance and Banking ---

Mergers & Acquisition Modelling

Total Days
26 Days
+
Total Hours
170 Hours
Training Mode
Price


Related Courses

Scenario & Sensitivity Analysis - Advance Excel Professional
Know More
3 - Statement Modelling - Level 4
Know More




Online BootcampPreferred
  • Flexi Pass Enabled: Flexibility to reschedule your cohort within first 90 days of access.
  • Live, online classroom training by top instructors and practitioners.
  • One year access to high-quality self-paced eLearning content curated by industry experts.
Classroom TrainingPreferred
  • Customized Training Solutions: Tailor classroom sessions to your team's needs, with options for instructor-led or blended learning formats.
  • One year access to high-quality self-paced eLearning content curated by industry experts.
  • Interactive Learning Environment: Engage with a simple, interactive setup that encourages active participation and hands-on learning.
Corporate Training
  • Customize the learning model according to your team's needs. Get digital material, instructor-led classes or both.
  • Get flexible pricing options according to your company's needs.
  • Simple and interactive Learning Management System (LMS).
  • Enterprise dashboard for individual learners or teams.
  • Learner support and assistance available 24/7.
  • One year access to high-quality self-paced eLearning content curated by industry experts.


Documents